<%@page import="javax.sql.DataSource"%>
<%@page import="com.ibm.portal.um.User"%>
<%@page import="javax.naming.InitialContext"%>
<%@page import="javax.naming.Context"%>
<%@page import="com.ibm.portal.um.PumaProfile"%>
<%@page import="com.ibm.portal.um.PumaHome"%>
<%@page import="javax.portlet.PortalContext"%>
<%@page import="Data.TblTudienDonvihanhchinh"%>
<%@page import="DAO.tblTuDiendonviDAO"%>
<%@page import="Data.IocBandoTentinh100kPoint"%>
<%@page import="Data.IocBandoTentinh100kPointHome"%>
<%@page import="DAO.ioc_tentinhDAO"%>
<%@page import="Data.IocThongtintiepnhanMucdokhancap"%>
<%@page import="DAO.ioc_mucdokhancapDAO"%>
<%@page import="Data.IocThongtintiepnhanMucdochacchan"%>
<%@page import="DAO.ioc_mucdochacchanDAO"%>
<%@page import="DAO.ioc_thongtintiepnhan_mucdonghiemtrongDAO"%>
<%@page import="DAO.ioc_thongtintiepnhanDAO"%>
<%@page import="Data.IocThongtintiepnhan"%>
<%@page import="Data.IocThongtintiepnhanMucdonghiemtrong"%>
<%@page session="false" contentType="text/html"
	pageEncoding="UTF-8"
	import="java.util.*,javax.portlet.*,com.ibm.iocc67.*"%>
<%@ taglib uri="http://java.sun.com/portlet_2_0" prefix="portlet"%>
<%@taglib
	uri="http://www.ibm.com/xmlns/prod/websphere/portal/v6.1/portlet-client-model"
	prefix="portlet-client-model"%>
<portlet:defineObjects />
<portlet:actionURL var="actionURL" />
<portlet-client-model:init>
	<portlet-client-model:require module="ibm.portal.xml.*" />
	<portlet-client-model:require module="ibm.portal.portlet.*" />
</portlet-client-model:init>
<!-- dojo parser call -->
<script type="text/javascript">
dojo.addOnLoad( function(){
	if(djConfig.parseOnLoad != true){
	   if(dojo.byId("widgetContainer_<portlet:namespace/>") != null)
		dojo.parser.parse(dojo.byId("widgetContainer_<portlet:namespace/>"));
	   else if(dojo.byId("mobileWidgetContainer_<portlet:namespace/>") != null)	
	    dojox.mobile.parser.parse(dojo.byId("mobileWidgetContainer_<portlet:namespace/>")); 
	}
});
</script>
<!-- end dojo parser call -->

<!-- global JavaScript portlet object creation -->
<% final String PORTLET_CONTEXT = renderResponse.encodeURL( renderRequest.getContextPath() ); %>

<script type="text/javascript">
    dojo.registerModulePath("portlet.namespace_da9095d444","<%=PORTLET_CONTEXT%>/js/portlet/namespace_da9095d444");

    dojo.require("portlet.namespace_da9095d444.Portlet");

    // A global variable to be used in parent jsp files.
    var portlet_<portlet:namespace/>;
    
    dojo.addOnLoad( function() {
      portlet_<portlet:namespace/> = new portlet.namespace_da9095d444.Portlet( {
        namespace   : "<portlet:namespace/>",
        contextPath : "<%=PORTLET_CONTEXT%>",
        actionUrl   : "<portlet:actionURL/>",
        renderUrl   : "<portlet:renderURL/>",
        remoteUser  : "<%= renderRequest.getRemoteUser() %>",
        portletMode : "<%= renderRequest.getPortletMode().toString() %>",
        windowState : "<%= renderRequest.getWindowState().toString() %>",
        scheme      : "<%= renderRequest.getScheme() %>"
      } );
    } );
</script>
<!-- end global JavaScript portlet object creation -->


<!-- include PortletHelper class and create object -->
<script type="text/javascript">
dojo.require("portlet.namespace_da9095d444.portlethelper.Thongtin_tiepnhanPortletView");
//The initial path segment portlet.namespace_da9095d444 is already registerd.

//the portletHelper object may be used in writing the business logic related to JavaScript for this portlet
//and its methods can be called in the format: portletHelper_<portlet:namespace/>.handler(argsToPass);
var portletHelper_<portlet:namespace/>;

dojo.addOnLoad( function() {
      portletHelper_<portlet:namespace/> = new portlet.namespace_da9095d444.portlethelper.Thongtin_tiepnhanPortletView({portlet: portlet_<portlet:namespace/>});
} );
</script>
<!-- end include PortletHelper class and create object -->


<script type="text/javascript">
dojo.require("dojo.parser");
</script>
<%
	com.ibm.iocc67.Thongtin_tiepnhanPortletSessionBean sessionBean = (com.ibm.iocc67.Thongtin_tiepnhanPortletSessionBean)renderRequest.getPortletSession().getAttribute(com.ibm.iocc67.Thongtin_tiepnhanPortlet.SESSION_BEAN);
%>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/jquery-2.0.2.min.js")%>'></script>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/jquery-2.0.2_.js")%>'></script>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/jquery-ui.js")%>'></script>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/slide.js")%>'></script>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/contextMenu.js")%>'></script>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/jquery.paginate.js")%>'></script>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/jquery.paginate.min.js")%>'></script>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/jquery.dataTables.js")%>'></script>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/jquery.dataTables.min.js")%>'></script>			
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/jquery.tablesorter.js")%>'></script>
<script
	src='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/js/ui/jquery.tablesorter.min.js")%>'></script>

<link rel="stylesheet" type="text/css"
	href='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/css/ui/styleSlide.css")%>'>
<%-- <link rel="stylesheet" type="text/css"
	href='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/css/ui/bootstrap-datepicker.css")%>'> --%>
<%-- <link rel="stylesheet" type="text/css"
	href='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/css/ui/jquery.timePicker.css")%>'> --%>
<%-- <link rel="stylesheet" type="text/css"
	href='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/css/ui/site.css")%>'> --%>
<link rel="stylesheet" type="text/css"
	href='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/css/ui/jquery-ui.css")%>'>
<link rel="stylesheet" type="text/css"
	href='<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/css/ui/contextMenu.css")%>'>
	
<script type="text/javascript">

$(document).ready(function()
{
$("#slTenTinh").change(function()
{
		var id=$(this).val();
		$.ajax
		({
			type: "GET",
			<%-- url : "<%=renderResponse.encodeURL(renderRequest.getContextPath())%>"+"/postgre_hibernate/Postgre_hibernatePortlet.java", --%>
			//url : "/wps/myportal/postgre_hibernate/Postgre_hibernatePortlet",
			///postgre_hibernate/src/com/ibm/postgre_hibernate/Postgre_hibernatePortlet.java
			//url : "/wps/myportal/cxml/WEB-INF/classes/com/ibm/postgre_hibernate/Controller/TinhHuyen.java",
			url : "<%=renderResponse.encodeURL(renderRequest.getContextPath())%>" + "/_tinh_huyen/jsp/html/tinhhuyen.jsp",
			data: {q: $("#slTenTinh").val()},
			success: function(data)
			{
				$("#slHuyen").html(data);
			}
		});
		$.ajax
		({
			type: "GET",
			<%-- url : "<%=renderResponse.encodeURL(renderRequest.getContextPath())%>"+"/postgre_hibernate/Postgre_hibernatePortlet.java", --%>
			//url : "/wps/myportal/postgre_hibernate/Postgre_hibernatePortlet",
			///postgre_hibernate/src/com/ibm/postgre_hibernate/Postgre_hibernatePortlet.java
			//url : "/wps/myportal/cxml/WEB-INF/classes/com/ibm/postgre_hibernate/Controller/TinhHuyen.java",
			url : "<%=renderResponse.encodeURL(renderRequest.getContextPath())%>" + "/_tinh_huyen/jsp/html/huyenxa.jsp",
			data: {q: $("#slTenTinh").val()},
			success: function(data)
			{
				$("#slXa").html(data);
			}
		});
	});
});
</script>
<script type="text/javascript">

$(document).ready(function()
{
$("#slHuyen").change(function()
{
		var id=$(this).val();
		$.ajax
		({
			type: "GET",
			<%-- url : "<%=renderResponse.encodeURL(renderRequest.getContextPath())%>"+"/postgre_hibernate/Postgre_hibernatePortlet.java", --%>
			//url : "/wps/myportal/postgre_hibernate/Postgre_hibernatePortlet",
			///postgre_hibernate/src/com/ibm/postgre_hibernate/Postgre_hibernatePortlet.java
			//url : "/wps/myportal/cxml/WEB-INF/classes/com/ibm/postgre_hibernate/Controller/TinhHuyen.java",
			url : "<%=renderResponse.encodeURL(renderRequest.getContextPath())%>" + "/_tinh_huyen/jsp/html/huyenxa.jsp",
			data: {p: $("#slHuyen").val()},
			success: function(data)
			{
				$("#slXa").html(data);
			}
		});
	});
});
</script>
<input type="text" id="txtHint"/>
<%
Context ctx = new InitialContext();
String myjndiname = PumaHome.JNDI_NAME;
PumaHome myHome = (PumaHome) ctx.lookup(myjndiname);
/* DataSource dataSource = ctx.lookup("java:comp/env/jdbc/ioc");
Connection conn = dataSource.getConnection(); */
if(myHome!=null){
	PumaProfile pumaProfile = myHome.getProfile();
	User user = pumaProfile.getCurrentUser();

	String[] strUser = user.toString().split(",");
	String uid = null;
	for(int i =0;i<=strUser.length;i++){
		if(strUser[i].contains("uid")){
			uid = strUser[i];
			break;
		}
	}
	String uid_final = uid.replace("id: uid=","");
	out.print(user);
}else{
	out.print("Unable");
} 

%>
<div id="content">
<div id="tabs">
		<ul>
			<li class="titleTab"><a href="#tabs-1">Access Information</a>
			</li>
			<li class="titleTab"><a href="#tabs-2">List Input Information</a>
			</li>
		</ul>
		<div id="tabs-1" class="subtabs">
			<form method="post" name="formEdit" id="formEdit" action="<%=actionURL %>" method="post">
				<table>
					<tr>
						<td> <strong>ID:</strong></td>
						<td colspan='3'><input style="background-color: #FFF573;"
							type="text" name="id" id="id" /></td>
						<td><strong>Tên liên hệ:</strong></td>
						<td colspan='3'><input type="text" name="ten_lienhe" id="ten_lienhe"/></td>
					</tr>
					<tr>
						<td>
						<strong>gID:</strong></td>
						<td colspan='3'><input style="background-color: #FFF573;"
							type="text" name="gid" id="gid" /></td>
						<td><strong>E-mail liên hệ:</strong></td>
						<td colspan='3'><input type="text" name="email_lienhe" id="email_lienhe"/></td>
					</tr>
					<tr>
						<td><input type="hidden" name="id" id="id"/>
						<strong>Người gửi:</strong></td>
						<td colspan='3'><input
							type="text" name="nguoi_gui" id="nguoi_gui" /></td>
						<td><strong>Điện thoại liên hệ:</strong></td>
						<td colspan='3'><input type="text" name="dienthoai_lienhe" id="dienthoai_lienhe"/>
						</td>
					</tr>
					<tr>
						<td colspan='4'><span class='DeMuc'>CÁI GÌ </span></td>
					</tr>
					<tr>
						<td><strong>Loại sự kiện:</strong></td>
						<td colspan='3'> <select name="slloai_sukien" id="slloai_sukien">
								<option value="5">Xử lý vi phạm</option>
								<option value="6">Dẫn đoàn</option>
						</select></td>
						<td><strong>Mức độ nghiêm trọng:</strong></td>
						<td colspan='3'> 
							<select name="slmucdo_nghiemtrong" id="slmucdo_nghiemtrong">
								<% 
								ioc_thongtintiepnhan_mucdonghiemtrongDAO objDAO_1 = new ioc_thongtintiepnhan_mucdonghiemtrongDAO();
								IocThongtintiepnhanMucdonghiemtrong[] list_mucdonghiemtrong = objDAO_1.getAll();
								for(int i=0;i<=list_mucdonghiemtrong.length-1;i++){
									IocThongtintiepnhanMucdonghiemtrong obj_md = list_mucdonghiemtrong[i];
								%>
								<option value="<%=obj_md.getId() %>"><%=obj_md.getTen() %></option>
								<%
								}
							 	%>
							</select>
						</td>
					</tr>
					<tr>
						<td><strong>Trạng thái sự kiện:</strong></td>
						<td colspan='3'><select name="sltrangthai_sukien" id="sltrangthai_sukien">
								<option value="1">Đang diễn ra</option>
								<option value="2">Chưa diễn ra</option>
						</select></td>
						<td><strong>Mức độ chắc chắn:</strong></td>
						<td colspan='3'> <select name="slmucdo_chacchan" id="slmucdo_chacchan">
								<% 
								ioc_mucdochacchanDAO objDAO_2 = new ioc_mucdochacchanDAO();
								IocThongtintiepnhanMucdochacchan[] list_mucdochacchan = objDAO_2.getAll();
								for(int i=0;i<=list_mucdochacchan.length-1;i++){
									IocThongtintiepnhanMucdochacchan obj_cc = list_mucdochacchan[i];
								%>
								<option value="<%=obj_cc.getId() %>"><%=obj_cc.getTen() %></option>
								<%
								}
							 	%>
						</select></td>
					</tr>
					<tr>
						<td><strong>Phạm vi sự kiện:</strong></td>
						<td colspan='3'><select name="slphamvi_sukien" id="slphamvi_sukien">
								<option value="1">Rộng</option>
								<option value="2">Bình thường</option>
						</select></td>
						<td><strong>Mức độ khẩn cấp:</strong></td>
						<td colspan='3'> <select name="slmucdo_khancap" id="slmucdo_khancap">
								<% 
								ioc_mucdokhancapDAO objDAO_3 = new ioc_mucdokhancapDAO();
								IocThongtintiepnhanMucdokhancap[] list_mucdokhancap = objDAO_3.getAll();
								for(int i=0;i<=list_mucdokhancap.length-1;i++){
									IocThongtintiepnhanMucdokhancap obj_kk = list_mucdokhancap[i];
								%>
								<option value="<%=obj_kk.getId() %>"><%=obj_kk.getTen() %></option>
								<%
								}
							 	%>
						</select></td>
					</tr>
					<tr>
						<td><strong>Hạn chế:</strong></td>
						<td colspan='3'><input type="text" name="han_che" id="han_che" /></td>
						<td><strong>Mô tả:</strong></td>
						<td colspan='3'><input type="text" name="mo_ta" id="mo_ta"/></td>
					</tr>
					<tr>
						<td><strong>Tiêu đề:</strong></td>
						<td colspan='3'><input type="text" name="tieu_de" id="tieu_de"/></td>
					</tr>
					<%-- <tr>
						<td><strong>Mức độ nghiêm trọng:</strong></td>
						<td colspan='3'> 
							<select name="slmucdo_nghiemtrong" id="slmucdo_nghiemtrong">
								<% 
								ioc_thongtintiepnhan_mucdonghiemtrongDAO objDAO_1 = new ioc_thongtintiepnhan_mucdonghiemtrongDAO();
								IocThongtintiepnhanMucdonghiemtrong[] list_mucdonghiemtrong = objDAO_1.getAll();
								for(int i=0;i<=list_mucdonghiemtrong.length-1;i++){
									IocThongtintiepnhanMucdonghiemtrong obj_md = list_mucdonghiemtrong[i];
								%>
								<option value="<%=obj_md.getId() %>"><%=obj_md.getTen() %></option>
								<%
								}
							 	%>
							</select>
						</td>
					</tr>
					<tr>
						<td><strong>Mức độ chắc chắn:</strong></td>
						<td colspan='3'> <select name="slmucdo_chacchan" id="slmucdo_chacchan">
								<% 
								ioc_mucdochacchanDAO objDAO_2 = new ioc_mucdochacchanDAO();
								IocThongtintiepnhanMucdochacchan[] list_mucdochacchan = objDAO_2.getAll();
								for(int i=0;i<=list_mucdochacchan.length-1;i++){
									IocThongtintiepnhanMucdochacchan obj_cc = list_mucdochacchan[i];
								%>
								<option value="<%=obj_cc.getId() %>"><%=obj_cc.getTen() %></option>
								<%
								}
							 	%>
						</select></td>
					</tr>
					<tr>
						<td><strong>Mức độ khẩn cấp:</strong></td>
						<td colspan='3'> <select name="slmucdo_khancap" id="slmucdo_khancap">
								<% 
								ioc_mucdokhancapDAO objDAO_3 = new ioc_mucdokhancapDAO();
								IocThongtintiepnhanMucdokhancap[] list_mucdokhancap = objDAO_3.getAll();
								for(int i=0;i<=list_mucdokhancap.length-1;i++){
									IocThongtintiepnhanMucdokhancap obj_kk = list_mucdokhancap[i];
								%>
								<option value="<%=obj_kk.getId() %>"><%=obj_kk.getTen() %></option>
								<%
								}
							 	%>
						</select></td>
					</tr>
					<tr>
						<td><strong>Mô tả:</strong></td>
						<td colspan='3'><input type="text" name="mo_ta" id="mo_ta"/></td>
					</tr> --%>
					<tr>
						<td colspan='5'><span class='DeMuc'>KHI NÀO </span></td>
						<td colspan='4'><span class='DeMuc'>Ở ĐÂU </span></td>
					</tr>
					<tr>
						<td><strong>Thời điểm gửi:</strong></td>
						<td colspan='3'>
						<span>Ngày:</span>
						<span><input class="date"
							type="text" id="ngay_gui" name='ngay_gui' value="" class="datepicker" readonly="readonly"/></span> </td>
						<td><span>Giờ:</span>
						<span><input name="thoidiem_gui" id="thoidiem_gui"/></span></td>
						<td colspan='3'>
							<span><strong>Mô tả khu vực:</strong></span>
							<span><input type="text" name="mota_khuvuc" id="mota_khuvuc"/></span></td>
					</tr>
					<tr>
						<td><strong>Thời điểm hiệu lực:</strong></td>
						<td colspan='3'>
							<span>Ngày:</span>
							<span> <input class="date" id='ngay_hieuluc' name='ngay_hieuluc' value="" class="datepicker" readonly="readonly"/> </span></td> 
						<td>
							<span>Giờ:</span>
							<span><input type="text" name="thoidiem_hieuluc" id="thoidiem_hieuluc"/></span>
						</td>
						<td colspan='3'><span><strong>Tỉnh:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</strong></span>
						<span><select id="slTenTinh" name="slTenTinh">
							<option value="">--Chọn Tỉnh--</option> 
								<% 
								tblTuDiendonviDAO objDAO_4 = new tblTuDiendonviDAO();
								TblTudienDonvihanhchinh[] list_tentinh = objDAO_4.getAllTinh();
								for(int i=0;i<=list_tentinh.length-1;i++){
									TblTudienDonvihanhchinh obj_tinh = list_tentinh[i];
								%>
								<option value="<%=obj_tinh.getMaTinh() %>"><%=obj_tinh.getTen() %></option>
								<%
								}
							 	%>
						</select></span></td>
					</tr>
					<tr>
						<td><strong>Thời điểm bắt đầu:</strong></td>
						<td colspan='3'><span>Ngày:</span> <span><input class="date"
							id='ngay_batdau' name="ngay_batdau" class="datepicker" readonly="readonly"/> </span>
						<td>
							<span>Giờ:</span>
							<span><input type="text" name="thoidiem_batdau" id="thoidiem_batdau" /></span>
						</td>
						<td colspan='3'><span><strong>Huyện:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</strong></span>
						<span>
							<select name="slHuyen" id="slHuyen" >
								<option value="">--Chọn Huyện--</option> 
							</select>
						</span>
						</td>
					</tr>
					<tr>
						<td><strong>Ngày kết thúc:</strong></td>
						<td colspan='3'>
							<span>Ngày:</span>
							<span><input class="date" id='ngay_ketthuc' name='ngay_ketthuc' value="" class="datepicker" readonly="readonly"/></span> 
						</td>
						<td><span>Giờ:</span>
							<span><input type="text" name="thoidiem_ketthuc" id="thoidiem_ketthuc" /></span>
						</td>
						<td colspan='3'><span><strong>Xã:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</strong></span>
						<span><select id="slXa" name="slXa">
								<option value="">--Chọn Xã--</option> 
						</select></span></td>
					</tr>
				</table>
				<div align="right">
					<input name="command" id="command" type="hidden"/>
					<input type="submit" name="<%=Thongtin_tiepnhanPortlet.FORM_SUBMIT%>" name="btnSubmit" value="Xác nhận" />
					<input type="reset" name="btnReset" value="Làm mới" />
				</div>
			</form>
			
		</div>
		<div id="tabs-2" class="subtabs">
			<div style="width:100%">
					<form>
						<input type="button" id="btnPreAdd" style="background-image: url(<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/images/add_new.png")%>)"/>
					</form>
			<table id="myTable" class="tablesorter">		
				<thead>	
					<tr>
						<th>ID</th>
						<th style="display:none;">gID</th>
						<th>Action</th>
						<th>Tỉnh</th>
						<th>Huyện</th>
						<th>Xã</th>
						<th>Ngày tạo</th>
						<th>Người tạo</th>
						<th>Người gửi</th>
						<th>Tên liên hệ</th>
						<th>Email liên hệ</th>
						<th>Điện thoại liên hệ</th>
						<th>Loại sự kiện</th>
						<th>Trạng thái sự kiện</th>
						<th>Phạm vi sự kiện</th>
						<th>Hạn chế</th>
						<th>Tiêu đề</th>
						<th>Mức độ nghiêm trọng</th>
						<th>Mức độ chắc chắn</th>
						<th>Mức độ khẩn cấp</th>
						<th>Mô tả</th>
						<th>Ngày gửi</th>
						<th>Thời điểm gửi</th>
						<th>Ngày hiệu lực</th>
						<th>Thời điểm hiệu lực</th>
						<th>Ngày bắt đầu</th>
						<th>Thời điểm bắt đầu</th>
						<th>Ngày kết thúc</th>
						<th>Thời điểm kết thúc</th>
						<th>Mô tả khu vực</th>
					</tr>
				</thead>
				<tbody>	
				<%
					ioc_thongtintiepnhanDAO objDAO = new ioc_thongtintiepnhanDAO();
					IocThongtintiepnhan[] listThongTin = objDAO.getAllThongTin();
					for(int i =0;i<=listThongTin.length-1;i++){
						IocThongtintiepnhan obj = listThongTin[i];
						String the_geom = obj.getTheGeom().substring(6, obj.getTheGeom().length()-2);
						String[] the_geom_final = the_geom.split(" ");
				%>
				<tr>
					<td><a onclick="panToPoint(map,'<%=the_geom_final[0] %>','<%=the_geom_final[1] %>')" href="javascript:void(0);"><%=obj.getId() %></a></td>
					<td style="display:none;"><%=obj.getGid() %></td>
					<td>
						<form name="frmDelete" id="frmDelete" action="<%=actionURL%>">
							<input type="hidden" id="longitude" name="longitude" value="<%=obj.getLongitude() %>"> 
							<input type="hidden" id="latitude" name="latitude" value="<%=obj.getLatitude() %>"> 
							<input type="hidden" id="id" name="id" value="<%=obj.getId() %>"> 
							<input type="hidden" id="command" name="command" value=""> 
							<input type="button" class="btnPreEdit" style="background-image: url(<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/images/edit.png")%>)"> 
							<input type="submit" class="btnPreDelete" name="<%=Thongtin_tiepnhanPortlet.FORM_SUBMIT %>" style="background-image: url(<%=renderResponse.encodeURL(renderRequest.getContextPath()+"/images/delete.png")%>)" value="">
						</form>
					</td>
					<td><%=obj.getMaTinh() %></td>
					<td><%=obj.getMaHuyen() %></td>
					<td><%=obj.getMaXa() %></td>
					<td><%=obj.getCreatedDate() %></td>
					<td><%=obj.getCreatedAccount() %></td>
					<td><%=obj.getNguoiGui() %></td>
					<td><%=obj.getTenLienhe() %></td>
					<td><%=obj.getEmailLienhe() %></td>
					<td><%=obj.getDienthoaiLienhe() %></td>
					<td><%=obj.getLoaiSukien() %></td>
					<td><%=obj.getTrangthaiSukien() %></td>
					<td><%=obj.getPhamviSukien() %></td>
					<td><%=obj.getHanChe() %></td>
					<td><%=obj.getTieuDe() %></td>
					<td><%=obj.getMucdoNghiemtrong() %></td>
					<td><%=obj.getMucdoChacchan() %></td>
					<td><%=obj.getMucdoKhancap() %></td>
					<td><%=obj.getMoTa() %></td>
					<td><%=obj.getNgayGui() %></td>
					<td><%=obj.getThoidiemGui() %></td>
					<td><%=obj.getNgayHieuluc() %></td>
					<td><%=obj.getThoidiemHieuluc() %></td>
					<td><%=obj.getNgayBatdau() %></td>
					<td><%=obj.getThoidiemBatdau() %></td>
					<td><%=obj.getNgayKetthuc() %></td>
					<td><%=obj.getThoidiemKetthuc() %></td>
					<td><%=obj.getMotaKhuvuc() %></td>
				</tr>
				<%
				}
				%>
				</tbody>
			</table>
			<div id="status"></div>
			<div id="paginate"></div>
			</div>
		</div>
	</div>
</DIV> 
<div id="widgetContainer_<portlet:namespace/>"></div>